POSIdentity

Entity Definition

Logical Name : POSIdentity
Physical Name : ID_PS

A simple cross-reference between the barcode, point of sale scan code or other keyed identifying number used at POS and the retailer business unit ID and internal stock keping ItemID for the item. The POSItemID will generally be filled with the GTIN (UPC, EAN etc) for an item -- but it is not mandatory -- A retailer may develop and maintain its own set of POS identifiers.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupID (FK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroupItem(AS_BSNGP_ITM)
BusinessUnitGroupID (FK)(PK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroup(CO_BSNGP)
POSItemIDQualifier (PK) A secondary qualifier on the POSItemID which denotes a separate item. Eg: When single bottles & six-packs of the same beverage both have the same UPC or other barcode, the POSItemIDQualifier holds denotes the two different items. ID_ITM_PS_QFR Identity integer
POSItemID (PK) The barcode, point of sale scan code or other keyed identifying number used at POS and the internal stock keping ItemID for the item. Will generally be filled with the GTIN (UPC, EAN etc) for an item -- but it is not mandatory -- A retailer may develop and maintain its own set of POS identifiers. ID_ITM_PS IdentityGTIN varchar(14)
ItemSellingPricesID (FK) A unique system assigned identifier for the ItemSellingPrices. ID_ITM_SL_PRC Identity integer ItemSellingPrices(RU_ITM_SL_PRC)
ItemSellingRuleID (FK) A unique system assigned identifier for the ItemSellingPrices. ID_RU_ITM_SL Identity integer ItemSellingRule(RU_ITM_SL)
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) BusinessUnitGroupItem(AS_BSNGP_ITM)
EffectiveDateTime (FK) The date from which the BusinessUnits in the group carry the Item. TS_EF EffectiveDateTime datetime BusinessUnitGroupItem(AS_BSNGP_ITM)

Relationships

Parent Entity Verb Phrase Child Entity
ItemSellingRule is assigned to POSIdentity
ItemSellingPrices is assigned to POSIdentity
BusinessUnitGroup defines POSIdentity
BusinessUnitGroupItem is identified via POSIdentity
POSIdentity identifies SaleReturnLineItem

Logical Views containing POSIdentity

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01020 - Item Description - Enterprise View
Logical 01100 - Item Selling Rules - Macro View
Logical 01110 - Item Selling Rules - Restrictions View
Logical 01120 - Item Selling Rules - Manufacturer Coupon View
Logical 02300 - Retail Transaction - Macro View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02333 - Retail Transaction - Tender - Coupon View
Logical 02370 - Retail Transaction - Rental View
Logical 10110 - Enterprise - Location Retailer Organization View
Logical 10300 - Enterprise - POS Department View
Logical 21000 - Fresh Item Management Macro View